Dataset statistics
| Number of variables | 72 |
|---|---|
| Number of observations | 837766 |
| Missing cells | 43832259 |
| Missing cells (%) | 72.7% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 460.2 MiB |
| Average record size in memory | 576.0 B |
Variable types
| CAT | 31 |
|---|---|
| BOOL | 22 |
| NUM | 11 |
| UNSUPPORTED | 8 |
Reproduction
| Analysis started | 2020-07-05 20:46:27.042288 |
|---|---|
| Analysis finished | 2020-07-05 20:51:51.733062 |
| Duration | 5 minutes and 24.69 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
CRASH_RECORD_ID has a high cardinality: 414426 distinct values | High cardinality |
RD_NO has a high cardinality: 410659 distinct values | High cardinality |
CRASH_DATE has a high cardinality: 268332 distinct values | High cardinality |
MAKE has a high cardinality: 909 distinct values | High cardinality |
MODEL has a high cardinality: 2143 distinct values | High cardinality |
LIC_PLATE_STATE has a high cardinality: 52 distinct values | High cardinality |
TOWED_BY has a high cardinality: 7298 distinct values | High cardinality |
TOWED_TO has a high cardinality: 7702 distinct values | High cardinality |
CARRIER_NAME has a high cardinality: 5945 distinct values | High cardinality |
CARRIER_CITY has a high cardinality: 1443 distinct values | High cardinality |
VEHICLE_ID is highly correlated with CRASH_UNIT_ID and 1 other fields | High correlation |
CRASH_UNIT_ID is highly correlated with VEHICLE_ID and 1 other fields | High correlation |
OCCUPANT_CNT is highly correlated with NUM_PASSENGERS | High correlation |
NUM_PASSENGERS is highly correlated with OCCUPANT_CNT | High correlation |
CMV_ID is highly correlated with CRASH_UNIT_ID and 1 other fields | High correlation |
NUM_PASSENGERS has 718762 (85.8%) missing values | Missing |
VEHICLE_ID has 17454 (2.1%) missing values | Missing |
CMRC_VEH_I has 822260 (98.1%) missing values | Missing |
MAKE has 17485 (2.1%) missing values | Missing |
MODEL has 19418 (2.3%) missing values | Missing |
LIC_PLATE_STATE has 84715 (10.1%) missing values | Missing |
VEHICLE_YEAR has 148417 (17.7%) missing values | Missing |
VEHICLE_DEFECT has 17454 (2.1%) missing values | Missing |
VEHICLE_TYPE has 17454 (2.1%) missing values | Missing |
VEHICLE_USE has 17454 (2.1%) missing values | Missing |
TRAVEL_DIRECTION has 17454 (2.1%) missing values | Missing |
MANEUVER has 17454 (2.1%) missing values | Missing |
TOWED_I has 749549 (89.5%) missing values | Missing |
FIRE_I has 837249 (99.9%) missing values | Missing |
OCCUPANT_CNT has 17454 (2.1%) missing values | Missing |
EXCEED_SPEED_LIMIT_I has 835407 (99.7%) missing values | Missing |
TOWED_BY has 773923 (92.4%) missing values | Missing |
TOWED_TO has 797332 (95.2%) missing values | Missing |
AREA_00_I has 803547 (95.9%) missing values | Missing |
AREA_01_I has 621754 (74.2%) missing values | Missing |
AREA_02_I has 687809 (82.1%) missing values | Missing |
AREA_03_I has 757701 (90.4%) missing values | Missing |
AREA_04_I has 751174 (89.7%) missing values | Missing |
AREA_05_I has 708242 (84.5%) missing values | Missing |
AREA_06_I has 714831 (85.3%) missing values | Missing |
AREA_07_I has 734840 (87.7%) missing values | Missing |
AREA_08_I has 686559 (82.0%) missing values | Missing |
AREA_09_I has 812559 (97.0%) missing values | Missing |
AREA_10_I has 800564 (95.6%) missing values | Missing |
AREA_11_I has 763625 (91.2%) missing values | Missing |
AREA_12_I has 765460 (91.4%) missing values | Missing |
AREA_99_I has 751710 (89.7%) missing values | Missing |
FIRST_CONTACT_POINT has 21456 (2.6%) missing values | Missing |
CMV_ID has 828732 (98.9%) missing values | Missing |
USDOT_NO has 832468 (99.4%) missing values | Missing |
CCMC_NO has 836608 (99.9%) missing values | Missing |
ILCC_NO has 836909 (99.9%) missing values | Missing |
COMMERCIAL_SRC has 831185 (99.2%) missing values | Missing |
GVWR has 832521 (99.4%) missing values | Missing |
CARRIER_NAME has 829095 (99.0%) missing values | Missing |
CARRIER_STATE has 829541 (99.0%) missing values | Missing |
CARRIER_CITY has 829690 (99.0%) missing values | Missing |
HAZMAT_PLACARDS_I has 837586 (> 99.9%) missing values | Missing |
HAZMAT_NAME has 837733 (> 99.9%) missing values | Missing |
UN_NO has 837430 (> 99.9%) missing values | Missing |
HAZMAT_PRESENT_I has 831130 (99.2%) missing values | Missing |
HAZMAT_REPORT_I has 831337 (99.2%) missing values | Missing |
HAZMAT_REPORT_NO has 837766 (100.0%) missing values | Missing |
MCS_REPORT_I has 831288 (99.2%) missing values | Missing |
MCS_REPORT_NO has 837761 (> 99.9%) missing values | Missing |
HAZMAT_VIO_CAUSE_CRASH_I has 831236 (99.2%) missing values | Missing |
MCS_VIO_CAUSE_CRASH_I has 831330 (99.2%) missing values | Missing |
IDOT_PERMIT_NO has 837227 (99.9%) missing values | Missing |
WIDE_LOAD_I has 837692 (> 99.9%) missing values | Missing |
TRAILER1_WIDTH has 835808 (99.8%) missing values | Missing |
TRAILER2_WIDTH has 837544 (> 99.9%) missing values | Missing |
TRAILER1_LENGTH has 836152 (99.8%) missing values | Missing |
TRAILER2_LENGTH has 837721 (> 99.9%) missing values | Missing |
TOTAL_VEHICLE_LENGTH has 835813 (99.8%) missing values | Missing |
AXLE_CNT has 835049 (99.7%) missing values | Missing |
VEHICLE_CONFIG has 830224 (99.1%) missing values | Missing |
CARGO_BODY_TYPE has 830540 (99.1%) missing values | Missing |
LOAD_TYPE has 830854 (99.2%) missing values | Missing |
HAZMAT_OUT_OF_SERVICE_I has 831529 (99.3%) missing values | Missing |
MCS_OUT_OF_SERVICE_I has 831353 (99.2%) missing values | Missing |
HAZMAT_CLASS has 837151 (99.9%) missing values | Missing |
VEHICLE_YEAR is highly skewed (γ1 = 49.02841634) | Skewed |
AXLE_CNT is highly skewed (γ1 = 52.12198557) | Skewed |
CRASH_RECORD_ID is uniformly distributed | Uniform |
RD_NO is uniformly distributed | Uniform |
CRASH_UNIT_ID has unique values | Unique |
USDOT_NO is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
CCMC_NO is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
ILCC_NO is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
GVWR is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
UN_NO is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
HAZMAT_REPORT_NO is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
MCS_REPORT_NO is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
IDOT_PERMIT_NO is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
OCCUPANT_CNT has 102317 (12.2%) zeros | Zeros |
| Distinct count | 837766 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 450031.11142252135 |
|---|---|
| Minimum | 2 |
| Maximum | 910029 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.4 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 43754.25 |
| Q1 | 220128.25 |
| median | 447564.5 |
| Q3 | 678641.75 |
| 95-th percentile | 863177.75 |
| Maximum | 910029 |
| Range | 910027 |
| Interquartile range (IQR) | 458513.5 |
Descriptive statistics
| Standard deviation | 263542.9848 |
|---|---|
| Coefficient of variation (CV) | 0.5856105902 |
| Kurtosis | -1.208981022 |
| Mean | 450031.1114 |
| Median Absolute Deviation (MAD) | 229218.5 |
| Skewness | 0.0220150255 |
| Sum | 3.770207641e+11 |
| Variance | 6.945490482e+10 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 665616 | 1 | < 0.1% | |
| 684059 | 1 | < 0.1% | |
| 686106 | 1 | < 0.1% | |
| 682008 | 1 | < 0.1% | |
| 659479 | 1 | < 0.1% | |
| 661526 | 1 | < 0.1% | |
| 655381 | 1 | < 0.1% | |
| 657428 | 1 | < 0.1% | |
| 667667 | 1 | < 0.1% | |
| Other values (837756) | 837756 | > 99.9% |
| Value | Count | Frequency (%) | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 910029 | 1 | < 0.1% | |
| 910028 | 1 | < 0.1% | |
| 910021 | 1 | < 0.1% | |
| 910020 | 1 | < 0.1% | |
| 910019 | 1 | < 0.1% |
| Distinct count | 414426 |
|---|---|
| Unique (%) | 49.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.4 MiB |
| e4f07da854d2b7be0c4c0903296e6f1a1f0109ddebca9d5b5dc399ffc698f2118f0f658ad5b1e3559714e0a3e2550720e3cb88e9753ce9a93ca3a20fa553fed7 | 18 |
|---|---|
| fb8d94334f5987710b7aa9cb4b0302f8e4c8f5f6e6d9f50ff0502a143737b3bfe95c37d970bcab190390797ad5c8fb6a9b6909f73186488c9b91267a4b844c65 | 16 |
| d128ebe105ed99a8372e21acc70d596bf4a64b28249e679ba33d4b450db5dba4621aa305e5e3cc8e31cab1beebf75645b34211d4dbbb434e5fb7d142c2569870 | 15 |
| 6485b8f4e89d7685abf38d22d3017003234343937ca227e63c5a20b17903a860917a4bbd523f716f1b926d551a25eaedcb61994139ff8fa4acbec2e7550722a4 | 12 |
| c2430f71beeeefd0a59b1c3e56e57c11f0a7ab04d90b1842d3cc726834ee65a94791bc13ef191959200e0ba1e07a9fce38e5b2d834858d3cf816c4c40de29961 | 12 |
| Other values (414421) |
| Value | Count | Frequency (%) | |
| e4f07da854d2b7be0c4c0903296e6f1a1f0109ddebca9d5b5dc399ffc698f2118f0f658ad5b1e3559714e0a3e2550720e3cb88e9753ce9a93ca3a20fa553fed7 | 18 | < 0.1% | |
| fb8d94334f5987710b7aa9cb4b0302f8e4c8f5f6e6d9f50ff0502a143737b3bfe95c37d970bcab190390797ad5c8fb6a9b6909f73186488c9b91267a4b844c65 | 16 | < 0.1% | |
| d128ebe105ed99a8372e21acc70d596bf4a64b28249e679ba33d4b450db5dba4621aa305e5e3cc8e31cab1beebf75645b34211d4dbbb434e5fb7d142c2569870 | 15 | < 0.1% | |
| 6485b8f4e89d7685abf38d22d3017003234343937ca227e63c5a20b17903a860917a4bbd523f716f1b926d551a25eaedcb61994139ff8fa4acbec2e7550722a4 | 12 | < 0.1% | |
| c2430f71beeeefd0a59b1c3e56e57c11f0a7ab04d90b1842d3cc726834ee65a94791bc13ef191959200e0ba1e07a9fce38e5b2d834858d3cf816c4c40de29961 | 12 | < 0.1% | |
| c9ea6db6a3665f9828881fc7c297f4967a76e059aac1622ec859780f626b40ffaf2ee0f78c87f49434ffec3e991ea9d543be0e8d85406a5215c518e76482b499 | 11 | < 0.1% | |
| 94ec1a051bc04155dc7b2be57e480b27908bc41b4a2eca60e887a21ab9f648e542e30046af9ef139c7a6720d4ff523403d6ce3c3cc244ec1dad63765c657ad5c | 11 | < 0.1% | |
| c1af6a8bcc100b6cd5a2c7c43adcdfba9e76a029ed1f7a0235a139a55428d3443a32d3c98c58498243370a230ff9031e42619a524519619f27d69e4cfa2edfee | 11 | < 0.1% | |
| f4d195b55b5f6541f9e29125d1c1599bf7980fcdfb2ff1b4d99c1a5d2d8faca86bf10824f3071f17cf7e773469bed11ed359b65e83486c8cabecd9276c151850 | 10 | < 0.1% | |
| 182f2fe6a3f75b93ca4589a8578548b7e4bdef14cafd1039386386daa3c74c4b0b1f7c7d1d7b3e3db0b27db3ecbe8fa30d4990b197702623b088f2f1bc35793b | 10 | < 0.1% | |
| Other values (414416) | 837640 | > 99.9% |
Length
| Max length | 128 |
|---|---|
| Median length | 128 |
| Mean length | 128 |
| Min length | 128 |
| Distinct count | 410659 |
|---|---|
| Unique (%) | 49.5% |
| Missing | 7719 |
| Missing (%) | 0.9% |
| Memory size | 6.4 MiB |
| JB311558 | 18 |
|---|---|
| JB330122 | 16 |
| JD141706 | 15 |
| JB530190 | 12 |
| JC406074 | 12 |
| Other values (410654) |
| Value | Count | Frequency (%) | |
| JB311558 | 18 | < 0.1% | |
| JB330122 | 16 | < 0.1% | |
| JD141706 | 15 | < 0.1% | |
| JB530190 | 12 | < 0.1% | |
| JC406074 | 12 | < 0.1% | |
| JD223633 | 11 | < 0.1% | |
| JA553317 | 11 | < 0.1% | |
| JC164705 | 11 | < 0.1% | |
| JA522872 | 10 | < 0.1% | |
| JD100146 | 10 | < 0.1% | |
| Other values (410649) | 829921 | 99.1% | |
| (Missing) | 7719 | 0.9% |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 7.95393105 |
| Min length | 3 |
| Distinct count | 268332 |
|---|---|
| Unique (%) | 32.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.4 MiB |
| 11/10/2017 10:30:00 AM | 58 |
|---|---|
| 11/10/2017 10:00:00 AM | 41 |
| 01/12/2019 02:30:00 PM | 39 |
| 01/12/2019 02:00:00 PM | 38 |
| 01/12/2019 03:00:00 PM | 37 |
| Other values (268327) |
| Value | Count | Frequency (%) | |
| 11/10/2017 10:30:00 AM | 58 | < 0.1% | |
| 11/10/2017 10:00:00 AM | 41 | < 0.1% | |
| 01/12/2019 02:30:00 PM | 39 | < 0.1% | |
| 01/12/2019 02:00:00 PM | 38 | < 0.1% | |
| 01/12/2019 03:00:00 PM | 37 | < 0.1% | |
| 02/26/2020 07:45:00 AM | 35 | < 0.1% | |
| 02/26/2020 08:00:00 AM | 32 | < 0.1% | |
| 09/04/2018 08:00:00 AM | 32 | < 0.1% | |
| 01/12/2019 04:00:00 PM | 31 | < 0.1% | |
| 10/10/2018 03:30:00 PM | 31 | < 0.1% | |
| Other values (268322) | 837392 | > 99.9% |
Length
| Max length | 22 |
|---|---|
| Median length | 22 |
| Mean length | 22 |
| Min length | 22 |
UNIT_NO
Real number (ℝ≥0)
| Distinct count | 19 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.555990574933812 |
|---|---|
| Minimum | 0 |
| Maximum | 18 |
| Zeros | 11 |
| Zeros (%) | < 0.1% |
| Memory size | 6.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 18 |
| Range | 18 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.6210063601 |
|---|---|
| Coefficient of variation (CV) | 0.399106762 |
| Kurtosis | 10.3017416 |
| Mean | 1.555990575 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.516570025 |
| Sum | 1303556 |
| Variance | 0.3856488993 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1 | 414038 | 49.4% | |
| 2 | 391615 | 46.7% | |
| 3 | 25346 | 3.0% | |
| 4 | 4840 | 0.6% | |
| 5 | 1238 | 0.1% | |
| 6 | 386 | < 0.1% | |
| 7 | 154 | < 0.1% | |
| 8 | 61 | < 0.1% | |
| 9 | 33 | < 0.1% | |
| 10 | 18 | < 0.1% | |
| Other values (9) | 37 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 11 | < 0.1% | |
| 1 | 414038 | 49.4% | |
| 2 | 391615 | 46.7% | |
| 3 | 25346 | 3.0% | |
| 4 | 4840 | 0.6% |
| Value | Count | Frequency (%) | |
| 18 | 1 | < 0.1% | |
| 17 | 1 | < 0.1% | |
| 16 | 2 | < 0.1% | |
| 15 | 3 | < 0.1% | |
| 14 | 3 | < 0.1% |
UNIT_TYPE
Categorical
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 11 |
| Missing (%) | < 0.1% |
| Memory size | 6.4 MiB |
| DRIVER | |
|---|---|
| PARKED | 103314 |
| PEDESTRIAN | 10564 |
| DRIVERLESS | 7667 |
| BICYCLE | 6044 |
| Other values (4) | 954 |
| Value | Count | Frequency (%) | |
| DRIVER | 709212 | 84.7% | |
| PARKED | 103314 | 12.3% | |
| PEDESTRIAN | 10564 | 1.3% | |
| DRIVERLESS | 7667 | 0.9% | |
| BICYCLE | 6044 | 0.7% | |
| NON-MOTOR VEHICLE | 759 | 0.1% | |
| NON-CONTACT VEHICLE | 161 | < 0.1% | |
| DISABLED VEHICLE | 29 | < 0.1% | |
| EQUESTRIAN | 5 | < 0.1% | |
| (Missing) | 11 | < 0.1% |
Length
| Max length | 19 |
|---|---|
| Median length | 6 |
| Mean length | 6.107054953 |
| Min length | 3 |
| Distinct count | 40 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 718762 |
| Missing (%) | 85.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.4887650835266042 |
|---|---|
| Minimum | 1.0 |
| Maximum | 59.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 59 |
| Range | 58 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.114858585 |
|---|---|
| Coefficient of variation (CV) | 0.7488478859 |
| Kurtosis | 296.1777592 |
| Mean | 1.488765084 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.89489652 |
| Sum | 177169 |
| Variance | 1.242909665 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1 | 83189 | 9.9% | |
| 2 | 22511 | 2.7% | |
| 3 | 8880 | 1.1% | |
| 4 | 2913 | 0.3% | |
| 5 | 794 | 0.1% | |
| 6 | 301 | < 0.1% | |
| 7 | 124 | < 0.1% | |
| 8 | 66 | < 0.1% | |
| 10 | 42 | < 0.1% | |
| 9 | 36 | < 0.1% | |
| Other values (30) | 148 | < 0.1% | |
| (Missing) | 718762 | 85.8% |
| Value | Count | Frequency (%) | |
| 1 | 83189 | 9.9% | |
| 2 | 22511 | 2.7% | |
| 3 | 8880 | 1.1% | |
| 4 | 2913 | 0.3% | |
| 5 | 794 | 0.1% |
| Value | Count | Frequency (%) | |
| 59 | 1 | < 0.1% | |
| 46 | 1 | < 0.1% | |
| 43 | 2 | < 0.1% | |
| 42 | 1 | < 0.1% | |
| 40 | 2 | < 0.1% |
| Distinct count | 820312 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 17454 |
| Missing (%) | 2.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 429604.923371839 |
|---|---|
| Minimum | 2.0 |
| Maximum | 862791.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.4 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 41829.55 |
| Q1 | 214449.75 |
| median | 428156 |
| Q3 | 645274.25 |
| 95-th percentile | 819137.45 |
| Maximum | 862791 |
| Range | 862789 |
| Interquartile range (IQR) | 430824.5 |
Descriptive statistics
| Standard deviation | 249060.5324 |
|---|---|
| Coefficient of variation (CV) | 0.5797431987 |
| Kurtosis | -1.197315586 |
| Mean | 429604.9234 |
| Median Absolute Deviation (MAD) | 215405.5 |
| Skewness | 0.008884082005 |
| Sum | 3.524100739e+11 |
| Variance | 6.203114882e+10 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 131071 | 1 | < 0.1% | |
| 396041 | 1 | < 0.1% | |
| 396049 | 1 | < 0.1% | |
| 24753 | 1 | < 0.1% | |
| 833904 | 1 | < 0.1% | |
| 396047 | 1 | < 0.1% | |
| 396046 | 1 | < 0.1% | |
| 396045 | 1 | < 0.1% | |
| 833905 | 1 | < 0.1% | |
| 596784 | 1 | < 0.1% | |
| Other values (820302) | 820302 | 97.9% | |
| (Missing) | 17454 | 2.1% |
| Value | Count | Frequency (%) | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 862791 | 1 | < 0.1% | |
| 862789 | 1 | < 0.1% | |
| 862782 | 1 | < 0.1% | |
| 862780 | 1 | < 0.1% | |
| 862779 | 1 | < 0.1% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 822260 |
| Missing (%) | 98.1% |
| Memory size | 6.4 MiB |
| Y | 10472 |
|---|---|
| N | 5034 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 10472 | 1.2% | |
| N | 5034 | 0.6% | |
| (Missing) | 822260 | 98.1% |
| Distinct count | 909 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 17485 |
| Missing (%) | 2.1% |
| Memory size | 6.4 MiB |
| CHEVROLET | |
|---|---|
| TOYOTA MOTOR COMPANY, LTD. | |
| FORD | |
| UNKNOWN | 80394 |
| NISSAN | 67980 |
| Other values (904) |
| Value | Count | Frequency (%) | |
| CHEVROLET | 96438 | 11.5% | |
| TOYOTA MOTOR COMPANY, LTD. | 87868 | 10.5% | |
| FORD | 81836 | 9.8% | |
| UNKNOWN | 80394 | 9.6% | |
| NISSAN | 67980 | 8.1% | |
| HONDA | 58756 | 7.0% | |
| DODGE | 37643 | 4.5% | |
| HYUNDAI | 33804 | 4.0% | |
| JEEP | 30975 | 3.7% | |
| KIA MOTORS CORP | 17279 | 2.1% | |
| Other values (899) | 227308 | 27.1% | |
| (Missing) | 17485 | 2.1% |
Length
| Max length | 60 |
|---|---|
| Median length | 7 |
| Mean length | 9.355866674 |
| Min length | 2 |
| Distinct count | 2143 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 19418 |
| Missing (%) | 2.3% |
| Memory size | 6.4 MiB |
| UNKNOWN | |
|---|---|
| CAMRY | 28533 |
| NISSAN ALTIMA | 17478 |
| COROLLA | 16570 |
| CIVIC | 15808 |
| Other values (2138) |
| Value | Count | Frequency (%) | |
| UNKNOWN | 177577 | 21.2% | |
| CAMRY | 28533 | 3.4% | |
| NISSAN ALTIMA | 17478 | 2.1% | |
| COROLLA | 16570 | 2.0% | |
| CIVIC | 15808 | 1.9% | |
| ACCORD | 14530 | 1.7% | |
| MALIBU (CHEVELLE) | 14206 | 1.7% | |
| IMPALA | 12723 | 1.5% | |
| SENTRA (DATSUN AND NISSAN HAVE MERGED) | 10925 | 1.3% | |
| ELANTRA | 9567 | 1.1% | |
| Other values (2133) | 500431 | 59.7% | |
| (Missing) | 19418 | 2.3% |
Length
| Max length | 60 |
|---|---|
| Median length | 7 |
| Mean length | 8.802459159 |
| Min length | 2 |
| Distinct count | 52 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 84715 |
| Missing (%) | 10.1% |
| Memory size | 6.4 MiB |
| IL | |
|---|---|
| XX | 23167 |
| IN | 13947 |
| WI | 4568 |
| MI | 3335 |
| Other values (47) | 21822 |
| Value | Count | Frequency (%) | |
| IL | 686212 | 81.9% | |
| XX | 23167 | 2.8% | |
| IN | 13947 | 1.7% | |
| WI | 4568 | 0.5% | |
| MI | 3335 | 0.4% | |
| FL | 1934 | 0.2% | |
| TX | 1900 | 0.2% | |
| OH | 1842 | 0.2% | |
| AZ | 1582 | 0.2% | |
| IA | 1343 | 0.2% | |
| Other values (42) | 13221 | 1.6% | |
| (Missing) | 84715 | 10.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.101120122 |
| Min length | 2 |
| Distinct count | 169 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 148417 |
| Missing (%) | 17.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2013.4487886397167 |
|---|---|
| Minimum | 1900.0 |
| Maximum | 9999.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.4 MiB |
Quantile statistics
| Minimum | 1900 |
|---|---|
| 5-th percentile | 1999 |
| Q1 | 2006 |
| median | 2011 |
| Q3 | 2015 |
| 95-th percentile | 2018 |
| Maximum | 9999 |
| Range | 8099 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 160.9657609 |
|---|---|
| Coefficient of variation (CV) | 0.07994529675 |
| Kurtosis | 2421.532809 |
| Mean | 2013.448789 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 49.02841634 |
| Sum | 1387968909 |
| Variance | 25909.97618 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 2015 | 56590 | 6.8% | |
| 2016 | 51813 | 6.2% | |
| 2014 | 50476 | 6.0% | |
| 2013 | 46013 | 5.5% | |
| 2017 | 45718 | 5.5% | |
| 2012 | 39799 | 4.8% | |
| 2007 | 35833 | 4.3% | |
| 2008 | 34173 | 4.1% | |
| 2011 | 33197 | 4.0% | |
| 2006 | 32213 | 3.8% | |
| Other values (159) | 263524 | 31.5% | |
| (Missing) | 148417 | 17.7% |
| Value | Count | Frequency (%) | |
| 1900 | 169 | < 0.1% | |
| 1901 | 11 | < 0.1% | |
| 1905 | 1 | < 0.1% | |
| 1911 | 1 | < 0.1% | |
| 1920 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 9999 | 274 | < 0.1% | |
| 9900 | 1 | < 0.1% | |
| 7999 | 1 | < 0.1% | |
| 7007 | 1 | < 0.1% | |
| 6414 | 2 | < 0.1% |
| Distinct count | 17 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 17454 |
| Missing (%) | 2.1% |
| Memory size | 6.4 MiB |
| NONE | |
|---|---|
| UNKNOWN | |
| OTHER | 4124 |
| BRAKES | 2754 |
| TIRES | 382 |
| Other values (12) | 1058 |
| Value | Count | Frequency (%) | |
| NONE | 488521 | 58.3% | |
| UNKNOWN | 323473 | 38.6% | |
| OTHER | 4124 | 0.5% | |
| BRAKES | 2754 | 0.3% | |
| TIRES | 382 | < 0.1% | |
| STEERING | 340 | < 0.1% | |
| WHEELS | 204 | < 0.1% | |
| SUSPENSION | 117 | < 0.1% | |
| ENGINE/MOTOR | 100 | < 0.1% | |
| FUEL SYSTEM | 97 | < 0.1% | |
| Other values (7) | 200 | < 0.1% | |
| (Missing) | 17454 | 2.1% |
Length
| Max length | 16 |
|---|---|
| Median length | 4 |
| Mean length | 5.155025389 |
| Min length | 3 |
| Distinct count | 22 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 17454 |
| Missing (%) | 2.1% |
| Memory size | 6.4 MiB |
| PASSENGER | |
|---|---|
| SPORT UTILITY VEHICLE (SUV) | |
| UNKNOWN/NA | 77127 |
| VAN/MINI-VAN | 42940 |
| PICKUP | 23834 |
| Other values (17) | 50206 |
| Value | Count | Frequency (%) | |
| PASSENGER | 520253 | 62.1% | |
| SPORT UTILITY VEHICLE (SUV) | 105952 | 12.6% | |
| UNKNOWN/NA | 77127 | 9.2% | |
| VAN/MINI-VAN | 42940 | 5.1% | |
| PICKUP | 23834 | 2.8% | |
| TRUCK - SINGLE UNIT | 16052 | 1.9% | |
| BUS OVER 15 PASS. | 9474 | 1.1% | |
| OTHER | 9202 | 1.1% | |
| TRACTOR W/ SEMI-TRAILER | 7951 | 0.9% | |
| MOTORCYCLE (OVER 150CC) | 1742 | 0.2% | |
| Other values (12) | 5785 | 0.7% | |
| (Missing) | 17454 | 2.1% |
Length
| Max length | 38 |
|---|---|
| Median length | 9 |
| Mean length | 11.79868006 |
| Min length | 3 |
| Distinct count | 25 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 17454 |
| Missing (%) | 2.1% |
| Memory size | 6.4 MiB |
| PERSONAL | |
|---|---|
| UNKNOWN/NA | |
| NOT IN USE | 39870 |
| OTHER | 25390 |
| TAXI/FOR HIRE | 15908 |
| Other values (20) | 49802 |
| Value | Count | Frequency (%) | |
| PERSONAL | 533170 | 63.6% | |
| UNKNOWN/NA | 156172 | 18.6% | |
| NOT IN USE | 39870 | 4.8% | |
| OTHER | 25390 | 3.0% | |
| TAXI/FOR HIRE | 15908 | 1.9% | |
| COMMERCIAL - SINGLE UNIT | 10841 | 1.3% | |
| RIDESHARE SERVICE | 8312 | 1.0% | |
| CTA | 5496 | 0.7% | |
| POLICE | 5338 | 0.6% | |
| OTHER TRANSIT | 3937 | 0.5% | |
| Other values (15) | 15878 | 1.9% | |
| (Missing) | 17454 | 2.1% |
Length
| Max length | 28 |
|---|---|
| Median length | 8 |
| Mean length | 8.805004023 |
| Min length | 3 |
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 17454 |
| Missing (%) | 2.1% |
| Memory size | 6.4 MiB |
| N | |
|---|---|
| S | |
| W | |
| E | |
| UNKNOWN | |
| Other values (4) | 35548 |
| Value | Count | Frequency (%) | |
| N | 193869 | 23.1% | |
| S | 187982 | 22.4% | |
| W | 171319 | 20.4% | |
| E | 167737 | 20.0% | |
| UNKNOWN | 63857 | 7.6% | |
| SE | 10419 | 1.2% | |
| NW | 9461 | 1.1% | |
| SW | 7846 | 0.9% | |
| NE | 7822 | 0.9% | |
| (Missing) | 17454 | 2.1% |
Length
| Max length | 7 |
|---|---|
| Median length | 1 |
| Mean length | 1.541437585 |
| Min length | 1 |
| Distinct count | 28 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 17454 |
| Missing (%) | 2.1% |
| Memory size | 6.4 MiB |
| STRAIGHT AHEAD | |
|---|---|
| PARKED | |
| SLOW/STOP IN TRAFFIC | 66598 |
| UNKNOWN/NA | 62754 |
| TURNING LEFT | 47399 |
| Other values (23) |
| Value | Count | Frequency (%) | |
| STRAIGHT AHEAD | 370161 | 44.2% | |
| PARKED | 106848 | 12.8% | |
| SLOW/STOP IN TRAFFIC | 66598 | 7.9% | |
| UNKNOWN/NA | 62754 | 7.5% | |
| TURNING LEFT | 47399 | 5.7% | |
| BACKING | 35864 | 4.3% | |
| TURNING RIGHT | 27576 | 3.3% | |
| PASSING/OVERTAKING | 19710 | 2.4% | |
| CHANGING LANES | 17481 | 2.1% | |
| OTHER | 13582 | 1.6% | |
| Other values (18) | 52339 | 6.2% | |
| (Missing) | 17454 | 2.1% |
Length
| Max length | 34 |
|---|---|
| Median length | 14 |
| Mean length | 12.88169608 |
| Min length | 3 |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 749549 |
| Missing (%) | 89.5% |
| Memory size | 6.4 MiB |
| Y | 82735 |
|---|---|
| N | 5482 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 82735 | 9.9% | |
| N | 5482 | 0.7% | |
| (Missing) | 749549 | 89.5% |
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 837249 |
| Missing (%) | 99.9% |
| Memory size | 6.4 MiB |
| Y | 287 |
|---|---|
| N | 230 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 287 | < 0.1% | |
| N | 230 | < 0.1% | |
| (Missing) | 837249 | 99.9% |
| Distinct count | 42 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 17454 |
| Missing (%) | 2.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0935912189508383 |
|---|---|
| Minimum | 0.0 |
| Maximum | 60.0 |
| Zeros | 102317 |
| Zeros (%) | 12.2% |
| Memory size | 6.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 60 |
| Range | 60 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.7918176361 |
|---|---|
| Coefficient of variation (CV) | 0.7240526647 |
| Kurtosis | 211.9485143 |
| Mean | 1.093591219 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.606486737 |
| Sum | 897086 |
| Variance | 0.6269751689 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1 | 598078 | 71.4% | |
| 0 | 102317 | 12.2% | |
| 2 | 83574 | 10.0% | |
| 3 | 22750 | 2.7% | |
| 4 | 9099 | 1.1% | |
| 5 | 2975 | 0.4% | |
| 6 | 789 | 0.1% | |
| 7 | 304 | < 0.1% | |
| 8 | 123 | < 0.1% | |
| 9 | 68 | < 0.1% | |
| Other values (32) | 235 | < 0.1% | |
| (Missing) | 17454 | 2.1% |
| Value | Count | Frequency (%) | |
| 0 | 102317 | 12.2% | |
| 1 | 598078 | 71.4% | |
| 2 | 83574 | 10.0% | |
| 3 | 22750 | 2.7% | |
| 4 | 9099 | 1.1% |
| Value | Count | Frequency (%) | |
| 60 | 1 | < 0.1% | |
| 47 | 1 | < 0.1% | |
| 44 | 2 | < 0.1% | |
| 43 | 1 | < 0.1% | |
| 41 | 2 | < 0.1% |
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 835407 |
| Missing (%) | 99.7% |
| Memory size | 6.4 MiB |
| Y | 1774 |
|---|---|
| N | 585 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 1774 | 0.2% | |
| N | 585 | 0.1% | |
| (Missing) | 835407 | 99.7% |
| Distinct count | 7298 |
|---|---|
| Unique (%) | 11.4% |
| Missing | 773923 |
| Missing (%) | 92.4% |
| Memory size | 6.4 MiB |
| PRIVATE TOW | 4849 |
|---|---|
| PRIVATE | 4847 |
| private | 3908 |
| CITY OF CHICAGO | 3828 |
| UNKNOWN | 3532 |
| Other values (7293) |
| Value | Count | Frequency (%) | |
| PRIVATE TOW | 4849 | 0.6% | |
| PRIVATE | 4847 | 0.6% | |
| private | 3908 | 0.5% | |
| CITY OF CHICAGO | 3828 | 0.5% | |
| UNKNOWN | 3532 | 0.4% | |
| private tow | 2909 | 0.3% | |
| city of chicago | 2339 | 0.3% | |
| UNK | 2095 | 0.3% | |
| unk | 2076 | 0.2% | |
| OWNER | 1761 | 0.2% | |
| Other values (7288) | 31699 | 3.8% | |
| (Missing) | 773923 | 92.4% |
Length
| Max length | 30 |
|---|---|
| Median length | 3 |
| Mean length | 3.563915222 |
| Min length | 1 |
| Distinct count | 7702 |
|---|---|
| Unique (%) | 19.0% |
| Missing | 797332 |
| Missing (%) | 95.2% |
| Memory size | 6.4 MiB |
| UNKNOWN | |
|---|---|
| UNK | 3568 |
| unknown | 3368 |
| unk | 2942 |
| PRIVATE | 633 |
| Other values (7697) |
| Value | Count | Frequency (%) | |
| UNKNOWN | 6016 | 0.7% | |
| UNK | 3568 | 0.4% | |
| unknown | 3368 | 0.4% | |
| unk | 2942 | 0.4% | |
| PRIVATE | 633 | 0.1% | |
| private | 566 | 0.1% | |
| 701 N SACRAMENTO | 415 | < 0.1% | |
| RESIDENCE | 364 | < 0.1% | |
| POUND 2 | 343 | < 0.1% | |
| POUND | 323 | < 0.1% | |
| Other values (7692) | 21896 | 2.6% | |
| (Missing) | 797332 | 95.2% |
Length
| Max length | 30 |
|---|---|
| Median length | 3 |
| Mean length | 3.312754397 |
| Min length | 1 |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 803547 |
| Missing (%) | 95.9% |
| Memory size | 6.4 MiB |
| Y | 29505 |
|---|---|
| N | 4714 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 29505 | 3.5% | |
| N | 4714 | 0.6% | |
| (Missing) | 803547 | 95.9% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 621754 |
| Missing (%) | 74.2% |
| Memory size | 6.4 MiB |
| Y | |
|---|---|
| N | 9524 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 206488 | 24.6% | |
| N | 9524 | 1.1% | |
| (Missing) | 621754 | 74.2% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 687809 |
| Missing (%) | 82.1% |
| Memory size | 6.4 MiB |
| Y | |
|---|---|
| N | 7353 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 142604 | 17.0% | |
| N | 7353 | 0.9% | |
| (Missing) | 687809 | 82.1% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 757701 |
| Missing (%) | 90.4% |
| Memory size | 6.4 MiB |
| Y | 76386 |
|---|---|
| N | 3679 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 76386 | 9.1% | |
| N | 3679 | 0.4% | |
| (Missing) | 757701 | 90.4% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 751174 |
| Missing (%) | 89.7% |
| Memory size | 6.4 MiB |
| Y | 82658 |
|---|---|
| N | 3934 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 82658 | 9.9% | |
| N | 3934 | 0.5% | |
| (Missing) | 751174 | 89.7% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 708242 |
| Missing (%) | 84.5% |
| Memory size | 6.4 MiB |
| Y | 124694 |
|---|---|
| N | 4830 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 124694 | 14.9% | |
| N | 4830 | 0.6% | |
| (Missing) | 708242 | 84.5% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 714831 |
| Missing (%) | 85.3% |
| Memory size | 6.4 MiB |
| Y | 117730 |
|---|---|
| N | 5205 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 117730 | 14.1% | |
| N | 5205 | 0.6% | |
| (Missing) | 714831 | 85.3% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 734840 |
| Missing (%) | 87.7% |
| Memory size | 6.4 MiB |
| Y | 98272 |
|---|---|
| N | 4654 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 98272 | 11.7% | |
| N | 4654 | 0.6% | |
| (Missing) | 734840 | 87.7% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 686559 |
| Missing (%) | 82.0% |
| Memory size | 6.4 MiB |
| Y | |
|---|---|
| N | 8089 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 143118 | 17.1% | |
| N | 8089 | 1.0% | |
| (Missing) | 686559 | 82.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 812559 |
| Missing (%) | 97.0% |
| Memory size | 6.4 MiB |
| Y | 23758 |
|---|---|
| N | 1449 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 23758 | 2.8% | |
| N | 1449 | 0.2% | |
| (Missing) | 812559 | 97.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 800564 |
| Missing (%) | 95.6% |
| Memory size | 6.4 MiB |
| Y | 35016 |
|---|---|
| N | 2186 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 35016 | 4.2% | |
| N | 2186 | 0.3% | |
| (Missing) | 800564 | 95.6% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 763625 |
| Missing (%) | 91.2% |
| Memory size | 6.4 MiB |
| Y | 69167 |
|---|---|
| N | 4974 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 69167 | 8.3% | |
| N | 4974 | 0.6% | |
| (Missing) | 763625 | 91.2% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 765460 |
| Missing (%) | 91.4% |
| Memory size | 6.4 MiB |
| Y | 69066 |
|---|---|
| N | 3240 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 69066 | 8.2% | |
| N | 3240 | 0.4% | |
| (Missing) | 765460 | 91.4% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 751710 |
| Missing (%) | 89.7% |
| Memory size | 6.4 MiB |
| Y | 82705 |
|---|---|
| N | 3351 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 82705 | 9.9% | |
| N | 3351 | 0.4% | |
| (Missing) | 751710 | 89.7% |
| Distinct count | 14 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 21456 |
| Missing (%) | 2.6% |
| Memory size | 6.4 MiB |
| FRONT | |
|---|---|
| REAR | |
| FRONT-LEFT | |
| REAR-LEFT | |
| FRONT-RIGHT | |
| Other values (9) |
| Value | Count | Frequency (%) | |
| FRONT | 144611 | 17.3% | |
| REAR | 96199 | 11.5% | |
| FRONT-LEFT | 83519 | 10.0% | |
| REAR-LEFT | 79417 | 9.5% | |
| FRONT-RIGHT | 77672 | 9.3% | |
| UNKNOWN | 74864 | 8.9% | |
| SIDE-LEFT | 53293 | 6.4% | |
| SIDE-RIGHT | 53152 | 6.3% | |
| OTHER | 52863 | 6.3% | |
| REAR-RIGHT | 38164 | 4.6% | |
| Other values (4) | 62556 | 7.5% |
Length
| Max length | 17 |
|---|---|
| Median length | 9 |
| Mean length | 7.730958287 |
| Min length | 3 |
| Distinct count | 9034 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 828732 |
| Missing (%) | 98.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5060.84868275404 |
|---|---|
| Minimum | 1.0 |
| Maximum | 10242.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 505.65 |
| Q1 | 2494.25 |
| median | 4994.5 |
| Q3 | 7647.75 |
| 95-th percentile | 9718.35 |
| Maximum | 10242 |
| Range | 10241 |
| Interquartile range (IQR) | 5153.5 |
Descriptive statistics
| Standard deviation | 2959.400933 |
|---|---|
| Coefficient of variation (CV) | 0.5847637656 |
| Kurtosis | -1.202361292 |
| Mean | 5060.848683 |
| Median Absolute Deviation (MAD) | 2574 |
| Skewness | 0.03839964655 |
| Sum | 45719707 |
| Variance | 8758053.88 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 8190 | 1 | < 0.1% | |
| 6996 | 1 | < 0.1% | |
| 2920 | 1 | < 0.1% | |
| 3221 | 1 | < 0.1% | |
| 805 | 1 | < 0.1% | |
| 3219 | 1 | < 0.1% | |
| 3218 | 1 | < 0.1% | |
| 804 | 1 | < 0.1% | |
| 3215 | 1 | < 0.1% | |
| 3223 | 1 | < 0.1% | |
| Other values (9024) | 9024 | 1.1% | |
| (Missing) | 828732 | 98.9% |
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 10242 | 1 | < 0.1% | |
| 10241 | 1 | < 0.1% | |
| 10240 | 1 | < 0.1% | |
| 10239 | 1 | < 0.1% | |
| 10238 | 1 | < 0.1% |
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 831185 |
| Missing (%) | 99.2% |
| Memory size | 6.4 MiB |
| SIDE OF TRUCK | |
|---|---|
| DRIVER | |
| PAPERS | |
| LOG BOOK | 480 |
| Value | Count | Frequency (%) | |
| SIDE OF TRUCK | 2768 | 0.3% | |
| DRIVER | 2361 | 0.3% | |
| PAPERS | 972 | 0.1% | |
| LOG BOOK | 480 | 0.1% | |
| (Missing) | 831185 | 99.2% |
Length
| Max length | 13 |
|---|---|
| Median length | 3 |
| Mean length | 3.047840328 |
| Min length | 3 |
| Distinct count | 5945 |
|---|---|
| Unique (%) | 68.6% |
| Missing | 829095 |
| Missing (%) | 99.0% |
| Memory size | 6.4 MiB |
| CHICAGO TRANSIT AUTHORITY | 309 |
|---|---|
| CTA | 189 |
| UNKNOWN | 103 |
| JB HUNT | 93 |
| CITY OF CHICAGO | 65 |
| Other values (5940) |
| Value | Count | Frequency (%) | |
| CHICAGO TRANSIT AUTHORITY | 309 | < 0.1% | |
| CTA | 189 | < 0.1% | |
| UNKNOWN | 103 | < 0.1% | |
| JB HUNT | 93 | < 0.1% | |
| CITY OF CHICAGO | 65 | < 0.1% | |
| UNK | 46 | < 0.1% | |
| JB HUNT TRANSPORT INC | 40 | < 0.1% | |
| PACE | 35 | < 0.1% | |
| PACE SUBURBAN BUS DIVISION | 33 | < 0.1% | |
| PENSKE TRUCK LEASING | 30 | < 0.1% | |
| Other values (5935) | 7728 | 0.9% | |
| (Missing) | 829095 | 99.0% |
Length
| Max length | 55 |
|---|---|
| Median length | 3 |
| Mean length | 3.168847864 |
| Min length | 2 |
| Distinct count | 47 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 829541 |
| Missing (%) | 99.0% |
| Memory size | 6.4 MiB |
| IL | |
|---|---|
| IN | 699 |
| WI | 276 |
| TX | 157 |
| MI | 154 |
| Other values (42) |
| Value | Count | Frequency (%) | |
| IL | 5191 | 0.6% | |
| IN | 699 | 0.1% | |
| WI | 276 | < 0.1% | |
| TX | 157 | < 0.1% | |
| MI | 154 | < 0.1% | |
| OH | 139 | < 0.1% | |
| IA | 132 | < 0.1% | |
| PA | 117 | < 0.1% | |
| AZ | 106 | < 0.1% | |
| MN | 104 | < 0.1% | |
| Other values (37) | 1150 | 0.1% | |
| (Missing) | 829541 | 99.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.990182223 |
| Min length | 2 |
| Distinct count | 1443 |
|---|---|
| Unique (%) | 17.9% |
| Missing | 829690 |
| Missing (%) | 99.0% |
| Memory size | 6.4 MiB |
| CHICAGO | |
|---|---|
| GARY | 121 |
| LOWELL | 93 |
| INDIANAPOLIS | 88 |
| NOBLESVILLE | 86 |
| Other values (1438) |
| Value | Count | Frequency (%) | |
| CHICAGO | 2095 | 0.3% | |
| GARY | 121 | < 0.1% | |
| LOWELL | 93 | < 0.1% | |
| INDIANAPOLIS | 88 | < 0.1% | |
| NOBLESVILLE | 86 | < 0.1% | |
| ARLINGTON HEIGHTS | 84 | < 0.1% | |
| CICERO | 78 | < 0.1% | |
| SKOKIE | 77 | < 0.1% | |
| DES PLAINES | 77 | < 0.1% | |
| ADDISON | 72 | < 0.1% | |
| Other values (1433) | 5205 | 0.6% | |
| (Missing) | 829690 | 99.0% |
Length
| Max length | 26 |
|---|---|
| Median length | 3 |
| Mean length | 3.053433775 |
| Min length | 1 |
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.1% |
| Missing | 837586 |
| Missing (%) | > 99.9% |
| Memory size | 6.4 MiB |
| N | 120 |
|---|---|
| Y | 60 |
| (Missing) |
| Value | Count | Frequency (%) | |
| N | 120 | < 0.1% | |
| Y | 60 | < 0.1% | |
| (Missing) | 837586 | > 99.9% |
| Distinct count | 24 |
|---|---|
| Unique (%) | 72.7% |
| Missing | 837733 |
| Missing (%) | > 99.9% |
| Memory size | 6.4 MiB |
| CORROSIVE | 3 |
|---|---|
| FLAMMABLE | 3 |
| PROPANE | 3 |
| FLAMMABLE LIQUID | 2 |
| GASOLINE | 2 |
| Other values (19) |
| Value | Count | Frequency (%) | |
| CORROSIVE | 3 | < 0.1% | |
| FLAMMABLE | 3 | < 0.1% | |
| PROPANE | 3 | < 0.1% | |
| FLAMMABLE LIQUID | 2 | < 0.1% | |
| GASOLINE | 2 | < 0.1% | |
| OXIDIZER | 2 | < 0.1% | |
| INTEGRAL SLEEPER | 1 | < 0.1% | |
| OXYGEN LIQUID | 1 | < 0.1% | |
| FUEL OIL | 1 | < 0.1% | |
| FLAME | 1 | < 0.1% | |
| Other values (14) | 14 | < 0.1% | |
| (Missing) | 837733 | > 99.9% |
Length
| Max length | 20 |
|---|---|
| Median length | 3 |
| Mean length | 3.000284089 |
| Min length | 1 |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 831130 |
| Missing (%) | 99.2% |
| Memory size | 6.4 MiB |
| N | |
|---|---|
| U | 400 |
| Y | 13 |
| Value | Count | Frequency (%) | |
| N | 6223 | 0.7% | |
| U | 400 | < 0.1% | |
| Y | 13 | < 0.1% | |
| (Missing) | 831130 | 99.2% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.984157867 |
| Min length | 1 |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 831337 |
| Missing (%) | 99.2% |
| Memory size | 6.4 MiB |
| N | |
|---|---|
| U | 811 |
| Y | 8 |
| Value | Count | Frequency (%) | |
| N | 5610 | 0.7% | |
| U | 811 | 0.1% | |
| Y | 8 | < 0.1% | |
| (Missing) | 831337 | 99.2% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.984652039 |
| Min length | 1 |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 831288 |
| Missing (%) | 99.2% |
| Memory size | 6.4 MiB |
| N | |
|---|---|
| U | |
| Y | 8 |
| Value | Count | Frequency (%) | |
| N | 5196 | 0.6% | |
| U | 1274 | 0.2% | |
| Y | 8 | < 0.1% | |
| (Missing) | 831288 | 99.2% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.984535061 |
| Min length | 1 |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 831236 |
| Missing (%) | 99.2% |
| Memory size | 6.4 MiB |
| N | |
|---|---|
| U | 484 |
| Y | 7 |
| Value | Count | Frequency (%) | |
| N | 6039 | 0.7% | |
| U | 484 | 0.1% | |
| Y | 7 | < 0.1% | |
| (Missing) | 831236 | 99.2% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.984410921 |
| Min length | 1 |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 831330 |
| Missing (%) | 99.2% |
| Memory size | 6.4 MiB |
| N | |
|---|---|
| U | 1013 |
| Y | 13 |
| Value | Count | Frequency (%) | |
| N | 5410 | 0.6% | |
| U | 1013 | 0.1% | |
| Y | 13 | < 0.1% | |
| (Missing) | 831330 | 99.2% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.984635328 |
| Min length | 1 |
| Distinct count | 2 |
|---|---|
| Unique (%) | 2.7% |
| Missing | 837692 |
| Missing (%) | > 99.9% |
| Memory size | 6.4 MiB |
| Y | 46 |
|---|---|
| N | 28 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 46 | < 0.1% | |
| N | 28 | < 0.1% | |
| (Missing) | 837692 | > 99.9% |
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 835808 |
| Missing (%) | 99.8% |
| Memory size | 6.4 MiB |
| 0-96 | |
|---|---|
| 97-102 | |
| >102 |
| Value | Count | Frequency (%) | |
| 0-96 | 1299 | 0.2% | |
| 97-102 | 397 | < 0.1% | |
| >102 | 262 | < 0.1% | |
| (Missing) | 835808 | 99.8% |
Length
| Max length | 6 |
|---|---|
| Median length | 3 |
| Mean length | 3.003284927 |
| Min length | 3 |
| Distinct count | 3 |
|---|---|
| Unique (%) | 1.4% |
| Missing | 837544 |
| Missing (%) | > 99.9% |
| Memory size | 6.4 MiB |
| 0-96 | |
|---|---|
| >102 | |
| 97-102 |
| Value | Count | Frequency (%) | |
| 0-96 | 138 | < 0.1% | |
| >102 | 46 | < 0.1% | |
| 97-102 | 38 | < 0.1% | |
| (Missing) | 837544 | > 99.9% |
Length
| Max length | 6 |
|---|---|
| Median length | 3 |
| Mean length | 3.000355708 |
| Min length | 3 |
| Distinct count | 76 |
|---|---|
| Unique (%) | 4.7% |
| Missing | 836152 |
| Missing (%) | 99.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 47.84634448574969 |
|---|---|
| Minimum | 1.0 |
| Maximum | 200.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 20 |
| Q1 | 40.25 |
| median | 53 |
| Q3 | 53 |
| 95-th percentile | 60 |
| Maximum | 200 |
| Range | 199 |
| Interquartile range (IQR) | 12.75 |
Descriptive statistics
| Standard deviation | 16.00437582 |
|---|---|
| Coefficient of variation (CV) | 0.3344952681 |
| Kurtosis | 8.200729415 |
| Mean | 47.84634449 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.835641432 |
| Sum | 77224 |
| Variance | 256.1400455 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 53 | 865 | 0.1% | |
| 48 | 95 | < 0.1% | |
| 40 | 90 | < 0.1% | |
| 30 | 52 | < 0.1% | |
| 20 | 40 | < 0.1% | |
| 50 | 36 | < 0.1% | |
| 52 | 32 | < 0.1% | |
| 45 | 26 | < 0.1% | |
| 28 | 23 | < 0.1% | |
| 25 | 23 | < 0.1% | |
| Other values (66) | 332 | < 0.1% | |
| (Missing) | 836152 | 99.8% |
| Value | Count | Frequency (%) | |
| 1 | 6 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 6 | 6 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| 8 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 200 | 1 | < 0.1% | |
| 125 | 1 | < 0.1% | |
| 120 | 3 | < 0.1% | |
| 115 | 4 | < 0.1% | |
| 114 | 1 | < 0.1% |
| Distinct count | 28 |
|---|---|
| Unique (%) | 62.2% |
| Missing | 837721 |
| Missing (%) | > 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 43.888888888888886 |
|---|---|
| Minimum | 2.0 |
| Maximum | 120.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.4 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8.4 |
| Q1 | 24 |
| median | 45 |
| Q3 | 53 |
| 95-th percentile | 96 |
| Maximum | 120 |
| Range | 118 |
| Interquartile range (IQR) | 29 |
Descriptive statistics
| Standard deviation | 28.544401 |
|---|---|
| Coefficient of variation (CV) | 0.6503787569 |
| Kurtosis | 0.1429226276 |
| Mean | 43.88888889 |
| Median Absolute Deviation (MAD) | 18 |
| Skewness | 0.7334259495 |
| Sum | 1975 |
| Variance | 814.7828283 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 53 | 9 | < 0.1% | |
| 25 | 3 | < 0.1% | |
| 96 | 3 | < 0.1% | |
| 48 | 2 | < 0.1% | |
| 12 | 2 | < 0.1% | |
| 60 | 2 | < 0.1% | |
| 14 | 2 | < 0.1% | |
| 40 | 2 | < 0.1% | |
| 50 | 1 | < 0.1% | |
| 43 | 1 | < 0.1% | |
| Other values (18) | 18 | < 0.1% | |
| (Missing) | 837721 | > 99.9% |
| Value | Count | Frequency (%) | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 10 | 1 | < 0.1% | |
| 12 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 120 | 1 | < 0.1% | |
| 99 | 1 | < 0.1% | |
| 96 | 3 | < 0.1% | |
| 90 | 1 | < 0.1% | |
| 73 | 1 | < 0.1% |
| Distinct count | 109 |
|---|---|
| Unique (%) | 5.6% |
| Missing | 835813 |
| Missing (%) | 99.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 52.26011264720942 |
|---|---|
| Minimum | 1.0 |
| Maximum | 535.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 32 |
| median | 53 |
| Q3 | 65 |
| 95-th percentile | 80 |
| Maximum | 535 |
| Range | 534 |
| Interquartile range (IQR) | 33 |
Descriptive statistics
| Standard deviation | 26.97302332 |
|---|---|
| Coefficient of variation (CV) | 0.5161302178 |
| Kurtosis | 61.01328285 |
| Mean | 52.26011265 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | 4.306772191 |
| Sum | 102064 |
| Variance | 727.5439871 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 65 | 182 | < 0.1% | |
| 53 | 161 | < 0.1% | |
| 40 | 137 | < 0.1% | |
| 75 | 122 | < 0.1% | |
| 60 | 109 | < 0.1% | |
| 63 | 97 | < 0.1% | |
| 70 | 91 | < 0.1% | |
| 30 | 75 | < 0.1% | |
| 20 | 74 | < 0.1% | |
| 68 | 67 | < 0.1% | |
| Other values (99) | 838 | 0.1% | |
| (Missing) | 835813 | 99.8% |
| Value | Count | Frequency (%) | |
| 1 | 2 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 6 | 4 | < 0.1% | |
| 7 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 535 | 1 | < 0.1% | |
| 305 | 1 | < 0.1% | |
| 265 | 1 | < 0.1% | |
| 245 | 2 | < 0.1% | |
| 196 | 1 | < 0.1% |
| Distinct count | 17 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 835049 |
| Missing (%) | 99.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.324622745675377 |
|---|---|
| Minimum | 1.0 |
| Maximum | 26009.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 26009 |
| Range | 26008 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 498.9121958 |
|---|---|
| Coefficient of variation (CV) | 37.44287589 |
| Kurtosis | 2716.800551 |
| Mean | 13.32462275 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 52.12198557 |
| Sum | 36203 |
| Variance | 248913.3791 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 5 | 848 | 0.1% | |
| 2 | 834 | 0.1% | |
| 3 | 620 | 0.1% | |
| 6 | 206 | < 0.1% | |
| 4 | 133 | < 0.1% | |
| 1 | 33 | < 0.1% | |
| 8 | 15 | < 0.1% | |
| 7 | 10 | < 0.1% | |
| 18 | 5 | < 0.1% | |
| 16 | 4 | < 0.1% | |
| Other values (7) | 9 | < 0.1% | |
| (Missing) | 835049 | 99.7% |
| Value | Count | Frequency (%) | |
| 1 | 33 | < 0.1% | |
| 2 | 834 | 0.1% | |
| 3 | 620 | 0.1% | |
| 4 | 133 | < 0.1% | |
| 5 | 848 | 0.1% |
| Value | Count | Frequency (%) | |
| 26009 | 1 | < 0.1% | |
| 99 | 1 | < 0.1% | |
| 77 | 1 | < 0.1% | |
| 55 | 1 | < 0.1% | |
| 18 | 5 | < 0.1% |
| Distinct count | 8 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 830224 |
| Missing (%) | 99.1% |
| Memory size | 6.4 MiB |
| TRACTOR/SEMI-TRAILER | |
|---|---|
| SINGLE UNIT TRUCK, 2 AXLES, 6 TIRES | |
| BUS | |
| TRUCK/TRACTOR | |
| TRUCK/TRAILER | 506 |
| Other values (3) |
| Value | Count | Frequency (%) | |
| TRACTOR/SEMI-TRAILER | 2910 | 0.3% | |
| SINGLE UNIT TRUCK, 2 AXLES, 6 TIRES | 1504 | 0.2% | |
| BUS | 1257 | 0.2% | |
| TRUCK/TRACTOR | 622 | 0.1% | |
| TRUCK/TRAILER | 506 | 0.1% | |
| UNKNOWN HEAVY TRUCK | 394 | < 0.1% | |
| SINGLE UNIT TRUCK, 3 OR MORE AXLES | 328 | < 0.1% | |
| TRACTOR/DOUBLES | 21 | < 0.1% | |
| (Missing) | 830224 | 99.1% |
Length
| Max length | 35 |
|---|---|
| Median length | 3 |
| Mean length | 3.149924919 |
| Min length | 3 |
| Distinct count | 9 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 830540 |
| Missing (%) | 99.1% |
| Memory size | 6.4 MiB |
| VAN/ENCLOSED BOX | |
|---|---|
| OTHER | |
| BUS | |
| FLATBED | 549 |
| DUMP | 267 |
| Other values (4) | 461 |
| Value | Count | Frequency (%) | |
| VAN/ENCLOSED BOX | 3189 | 0.4% | |
| OTHER | 1546 | 0.2% | |
| BUS | 1214 | 0.1% | |
| FLATBED | 549 | 0.1% | |
| DUMP | 267 | < 0.1% | |
| GARBAGE/REFUSE | 178 | < 0.1% | |
| TANK | 146 | < 0.1% | |
| AUTO TRANSPORTER | 70 | < 0.1% | |
| CONCRETE MIXER | 67 | < 0.1% | |
| (Missing) | 830540 | 99.1% |
Length
| Max length | 16 |
|---|---|
| Median length | 3 |
| Mean length | 3.060593292 |
| Min length | 3 |
| Distinct count | 6 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 830854 |
| Missing (%) | 99.2% |
| Memory size | 6.4 MiB |
| OTHER | |
|---|---|
| UNKNOWN | |
| CONSTRUCTION EQUIPMENT | 238 |
| BUILDING MATERIALS | 144 |
| STEEL COILS | 34 |
| Value | Count | Frequency (%) | |
| OTHER | 3957 | 0.5% | |
| UNKNOWN | 2529 | 0.3% | |
| CONSTRUCTION EQUIPMENT | 238 | < 0.1% | |
| BUILDING MATERIALS | 144 | < 0.1% | |
| STEEL COILS | 34 | < 0.1% | |
| FARM EQUIPMENT | 10 | < 0.1% | |
| (Missing) | 830854 | 99.2% |
Length
| Max length | 22 |
|---|---|
| Median length | 3 |
| Mean length | 3.029953471 |
| Min length | 3 |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 831529 |
| Missing (%) | 99.3% |
| Memory size | 6.4 MiB |
| N | 6228 |
|---|---|
| Y | 9 |
| (Missing) |
| Value | Count | Frequency (%) | |
| N | 6228 | 0.7% | |
| Y | 9 | < 0.1% | |
| (Missing) | 831529 | 99.3% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 831353 |
| Missing (%) | 99.2% |
| Memory size | 6.4 MiB |
| N | 6381 |
|---|---|
| Y | 32 |
| (Missing) |
| Value | Count | Frequency (%) | |
| N | 6381 | 0.8% | |
| Y | 32 | < 0.1% | |
| (Missing) | 831353 | 99.2% |
| Distinct count | 8 |
|---|---|
| Unique (%) | 1.3% |
| Missing | 837151 |
| Missing (%) | 99.9% |
| Memory size | 6.4 MiB |
| MISCELLANEOUS | |
|---|---|
| FLAMMABLE OR COMBUSTIBLE LIQUID | 40 |
| GASES | 16 |
| EXPLOSIVES | 16 |
| CORROSIVE | 11 |
| Other values (3) | 5 |
| Value | Count | Frequency (%) | |
| MISCELLANEOUS | 527 | 0.1% | |
| FLAMMABLE OR COMBUSTIBLE LIQUID | 40 | < 0.1% | |
| GASES | 16 | < 0.1% | |
| EXPLOSIVES | 16 | < 0.1% | |
| CORROSIVE | 11 | < 0.1% | |
| FLAMMABLE SOLID, SPONTANEOUSLY COMBUSTIBLE, OR DANGEROUS WHEN WET | 2 | < 0.1% | |
| OXIDIZER OR ORGANIC PEROXIDE | 2 | < 0.1% | |
| POISON (TOXIC) OR POISON INHALATION HAZARD | 1 | < 0.1% | |
| (Missing) | 837151 | 99.9% |
Length
| Max length | 65 |
|---|---|
| Median length | 3 |
| Mean length | 3.008132342 |
| Min length | 3 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| CRASH_UNIT_ID | CRASH_RECORD_ID | RD_NO | CRASH_DATE | UNIT_NO | UNIT_TYPE | NUM_PASSENGERS | VEHICLE_ID | CMRC_VEH_I | MAKE | MODEL | LIC_PLATE_STATE | VEHICLE_YEAR | VEHICLE_DEFECT | VEHICLE_TYPE | VEHICLE_USE | TRAVEL_DIRECTION | MANEUVER | TOWED_I | FIRE_I | OCCUPANT_CNT | EXCEED_SPEED_LIMIT_I | TOWED_BY | TOWED_TO | AREA_00_I | AREA_01_I | AREA_02_I | AREA_03_I | AREA_04_I | AREA_05_I | AREA_06_I | AREA_07_I | AREA_08_I | AREA_09_I | AREA_10_I | AREA_11_I | AREA_12_I | AREA_99_I | FIRST_CONTACT_POINT | CMV_ID | USDOT_NO | CCMC_NO | ILCC_NO | COMMERCIAL_SRC | GVWR | CARRIER_NAME | CARRIER_STATE | CARRIER_CITY | HAZMAT_PLACARDS_I | HAZMAT_NAME | UN_NO | HAZMAT_PRESENT_I | HAZMAT_REPORT_I | HAZMAT_REPORT_NO | MCS_REPORT_I | MCS_REPORT_NO | HAZMAT_VIO_CAUSE_CRASH_I | MCS_VIO_CAUSE_CRASH_I | IDOT_PERMIT_NO | WIDE_LOAD_I | TRAILER1_WIDTH | TRAILER2_WIDTH | TRAILER1_LENGTH | TRAILER2_LENGTH | TOTAL_VEHICLE_LENGTH | AXLE_CNT | VEHICLE_CONFIG | CARGO_BODY_TYPE | LOAD_TYPE | HAZMAT_OUT_OF_SERVICE_I | MCS_OUT_OF_SERVICE_I | HAZMAT_CLASS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 10 | 2e31858c0e411f0bdcb337fb7c415aa93763cf2f23e02fb278e2ed4cf855d36c5a83f270e6f2e0e234ec48b4a0e55a2c51e37b0d40677392c25079c51727a57f | HY368708 | 08/04/2015 12:40:00 PM | 1 | DRIVER | NaN | 10.0 | NaN | FORD | Focus | IL | 2001.0 | NONE | PASSENGER | PERSONAL | N | TURNING LEFT | NaN | NaN | 1.0 | NaN | NaN | NaN | N | Y | Y | NaN | NaN | NaN | NaN | NaN | Y | NaN | NaN | NaN | NaN | NaN | FRONT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | 100 | e73b35bd7651b0c6693162bee0666db159b2890143700936741e9ad9cfc1b0d7f71c0f63dc0594ecdd6fd2183fa2dcd67dfa76a4799839a00a81bc45e3966bb1 | HY374018 | 07/31/2015 05:50:00 PM | 1 | DRIVER | NaN | 96.0 | NaN | NISSAN | Pathfinder | IL | 1999.0 | NONE | SPORT UTILITY VEHICLE (SUV) | PERSONAL | E | STRAIGHT AHEAD | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | Y | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | FRONT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2 | 1000 | f2b1adeb85a15112e4fb7db74bff440d6ca53ff7a21e10490081685db85460a53c0f3d52dc0e181e69348053ef3198dccbc24e01df9179e42331bc4345e6f28d | HY407431 | 09/02/2015 11:45:00 AM | 1 | DRIVER | NaN | 954.0 | NaN | FORD | F150 | KS | NaN | UNKNOWN | VAN/MINI-VAN | UNKNOWN/NA | W | STRAIGHT AHEAD | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Y | FRONT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 3 | 10000 | 15a3e24fce3ce7cd2b02d44013d1a93ff2fbdca80632ecca87150673b21e819bd8649e309f867728fd25a9a9fcb6f0f2c00c42ab6733e4d6945262dbe6c90c0e | HY484148 | 10/31/2015 09:30:00 PM | 2 | DRIVER | NaN | 9561.0 | NaN | HYUNDAI | SONATA | NaN | 2011.0 | NONE | PASSENGER | PERSONAL | E | SLOW/STOP IN TRAFFIC | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | REAR | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 4 | 100000 | 1d3c178880366c77deaf06b8c3198429112a1c8e8807ed95cea7b44e891a873df5b99852206a32d25fe2ede813c2149f25a43b7d2d3e1cc24b62fa437abd638f | HZ518934 | 11/16/2016 01:00:00 PM | 2 | PARKED | NaN | 96745.0 | NaN | TOYOTA MOTOR COMPANY, LTD. | RAV4 (sport utility) | IL | 2001.0 | UNKNOWN | SPORT UTILITY VEHICLE (SUV) | NOT IN USE | S | PARKED | NaN | NaN | 0.0 | NaN | NaN | NaN | N | Y | NaN | NaN | NaN | Y | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | UNKNOWN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 5 | 100001 | 2fcefeab458932d8b1b12e103c18c50adc659943cccd4b17fc22124a16b1ba9df582f703cd07e7ba892d00b904c9a9849b7c0b6a39063c00e829a752fe22f206 | HZ525619 | 11/15/2016 05:45:00 PM | 1 | DRIVER | NaN | 96762.0 | NaN | UNKNOWN | UNKNOWN | NaN | NaN | UNKNOWN | UNKNOWN/NA | UNKNOWN/NA | UNKNOWN | UNKNOWN/NA | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Y | Y | Y | NaN | NaN | NaN | NaN | NaN | SIDE-LEFT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 6 | 100002 | 2fcefeab458932d8b1b12e103c18c50adc659943cccd4b17fc22124a16b1ba9df582f703cd07e7ba892d00b904c9a9849b7c0b6a39063c00e829a752fe22f206 | HZ525619 | 11/15/2016 05:45:00 PM | 2 | DRIVER | NaN | 96754.0 | NaN | DODGE | CARAVAN | IL | 2012.0 | NONE | PASSENGER | PERSONAL | E | STRAIGHT AHEAD | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | Y | Y | Y | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | SIDE-LEFT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 7 | 100003 | c2f21fd14725cf30d43ae59057e59b2e225c9e62a846e7995a6fbf041a23f4578ac02ec12570a1451580b566e134a1aeccceabfc653a1b9a8ca87d122d2bd3e8 | HZ525629 | 11/22/2016 01:45:00 PM | 1 | DRIVER | NaN | 96757.0 | NaN | NISSAN | UNKNOWN | IL | 2006.0 | NONE | PASSENGER | PERSONAL | N | STRAIGHT AHEAD | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | Y | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | FRONT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 8 | 100004 | c2f21fd14725cf30d43ae59057e59b2e225c9e62a846e7995a6fbf041a23f4578ac02ec12570a1451580b566e134a1aeccceabfc653a1b9a8ca87d122d2bd3e8 | HZ525629 | 11/22/2016 01:45:00 PM | 2 | DRIVER | NaN | 96755.0 | NaN | TOYOTA MOTOR COMPANY, LTD. | COROLLA | IL | 2008.0 | NONE | PASSENGER | PERSONAL | N | SLOW/STOP IN TRAFFIC | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Y | NaN | NaN | NaN | REAR | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 9 | 100005 | 5bfddf5ec81892bf71c2ba0f807c1ec112fd7ecdecbf3c6abbcea4314d7333fc6a4a058537ee8e97dbbb73019444b810f8aabe493003563d25736a5bd2c278a9 | HZ525606 | 11/19/2016 06:35:00 PM | 1 | DRIVER | NaN | 96759.0 | NaN | BUICK | UNKNOWN | IL | 2012.0 | UNKNOWN | PASSENGER | PERSONAL | N | CHANGING LANES | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | Y | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | FRONT-RIGHT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
Last rows
| CRASH_UNIT_ID | CRASH_RECORD_ID | RD_NO | CRASH_DATE | UNIT_NO | UNIT_TYPE | NUM_PASSENGERS | VEHICLE_ID | CMRC_VEH_I | MAKE | MODEL | LIC_PLATE_STATE | VEHICLE_YEAR | VEHICLE_DEFECT | VEHICLE_TYPE | VEHICLE_USE | TRAVEL_DIRECTION | MANEUVER | TOWED_I | FIRE_I | OCCUPANT_CNT | EXCEED_SPEED_LIMIT_I | TOWED_BY | TOWED_TO | AREA_00_I | AREA_01_I | AREA_02_I | AREA_03_I | AREA_04_I | AREA_05_I | AREA_06_I | AREA_07_I | AREA_08_I | AREA_09_I | AREA_10_I | AREA_11_I | AREA_12_I | AREA_99_I | FIRST_CONTACT_POINT | CMV_ID | USDOT_NO | CCMC_NO | ILCC_NO | COMMERCIAL_SRC | GVWR | CARRIER_NAME | CARRIER_STATE | CARRIER_CITY | HAZMAT_PLACARDS_I | HAZMAT_NAME | UN_NO | HAZMAT_PRESENT_I | HAZMAT_REPORT_I | HAZMAT_REPORT_NO | MCS_REPORT_I | MCS_REPORT_NO | HAZMAT_VIO_CAUSE_CRASH_I | MCS_VIO_CAUSE_CRASH_I | IDOT_PERMIT_NO | WIDE_LOAD_I | TRAILER1_WIDTH | TRAILER2_WIDTH | TRAILER1_LENGTH | TRAILER2_LENGTH | TOTAL_VEHICLE_LENGTH | AXLE_CNT | VEHICLE_CONFIG | CARGO_BODY_TYPE | LOAD_TYPE | HAZMAT_OUT_OF_SERVICE_I | MCS_OUT_OF_SERVICE_I | HAZMAT_CLASS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 837756 | 903038 | b6b89d3e6f386c124c7bd0ca58c0979e324cd367dc4b6ae1eee837536b137dd74a5a33f4dbfa4d7bf74b54ebca72a26749a8e8967d601bbd51c0dbdcf3d4296a | JD270339 | 06/16/2020 09:25:00 PM | 1 | DRIVER | NaN | 856268.0 | NaN | STERLING | OTHER (EXPLAIN IN NARRATIVE) | IL | 2007.0 | UNKNOWN | UNKNOWN/NA | UNKNOWN/NA | W | STRAIGHT AHEAD | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | Y | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | FRONT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 837757 | 903039 | b6b89d3e6f386c124c7bd0ca58c0979e324cd367dc4b6ae1eee837536b137dd74a5a33f4dbfa4d7bf74b54ebca72a26749a8e8967d601bbd51c0dbdcf3d4296a | JD270339 | 06/16/2020 09:25:00 PM | 2 | PARKED | 4.0 | 856274.0 | NaN | FORD | EXPLORER | IL | 2004.0 | UNKNOWN | SPORT UTILITY VEHICLE (SUV) | UNKNOWN/NA | W | PARKED | NaN | NaN | 4.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Y | NaN | NaN | NaN | NaN | NaN | NaN | FRONT-LEFT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 837758 | 903883 | 5526a4009f96cf49b607eed87ab770599919c08bd03e3b164f738c9318cd54fffb1e3ce1d13a29a5fc5ccf3d86106ea37ece3056b98b88fcfe96db31603ec9b7 | JD266343 | 06/16/2020 07:45:00 PM | 1 | DRIVER | NaN | 857068.0 | NaN | CHRYSLER | SEBRING | IL | 2002.0 | UNKNOWN | PASSENGER | PERSONAL | E | UNKNOWN/NA | Y | NaN | 1.0 | NaN | e&r | 103rd and doty | NaN | Y | Y | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Y | Y | Y | NaN | OTHER | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 837759 | 903884 | 5526a4009f96cf49b607eed87ab770599919c08bd03e3b164f738c9318cd54fffb1e3ce1d13a29a5fc5ccf3d86106ea37ece3056b98b88fcfe96db31603ec9b7 | JD266343 | 06/16/2020 07:45:00 PM | 2 | DRIVER | NaN | 857069.0 | NaN | NISSAN | ROGUE | IL | 2018.0 | NONE | PASSENGER | PERSONAL | W | OTHER | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Y | NaN | NaN | NaN | NaN | NaN | NaN | SIDE-LEFT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 837760 | 904947 | f8789485a2c59cc21aaca437a448821a33a42b4be8de6f06f49ba6fa5feef2c01a18bcbf4ccc2d811d77c4867f8d00ec3678f70295f311a696840131f580c115 | JD273627 | 06/16/2020 02:00:00 PM | 1 | DRIVER | NaN | 858084.0 | Y | FREIGHTLINER CORPORATION | OTHER (EXPLAIN IN NARRATIVE) | IL | 1998.0 | UNKNOWN | TRUCK - SINGLE UNIT | COMMERCIAL - SINGLE UNIT | E | TURNING RIGHT | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | Y | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | FRONT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 837761 | 904948 | f8789485a2c59cc21aaca437a448821a33a42b4be8de6f06f49ba6fa5feef2c01a18bcbf4ccc2d811d77c4867f8d00ec3678f70295f311a696840131f580c115 | JD273627 | 06/16/2020 02:00:00 PM | 2 | DRIVER | NaN | 858089.0 | NaN | DODGE | RAM 1500 PU | IL | 2016.0 | NONE | PICKUP | OTHER | E | TURNING RIGHT | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Y | NaN | NaN | NaN | NaN | ROOF | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 837762 | 905072 | c7da7a2778969bfebbfa528ce03c975c21412b82fd7b61e8666fd85f6d6f402cb465831ee8e19b57a7eb2fd43c030e1fc20d61d4b0ac5a2df4813aaf1a5815f4 | JD273565 | 06/16/2020 12:30:00 PM | 1 | DRIVER | NaN | 858203.0 | NaN | CHRYSLER | OTHER (EXPLAIN IN NARRATIVE) | IL | 2007.0 | UNKNOWN | PASSENGER | PERSONAL | N | STRAIGHT AHEAD | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Y | UNKNOWN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 837763 | 905073 | c7da7a2778969bfebbfa528ce03c975c21412b82fd7b61e8666fd85f6d6f402cb465831ee8e19b57a7eb2fd43c030e1fc20d61d4b0ac5a2df4813aaf1a5815f4 | JD273565 | 06/16/2020 12:30:00 PM | 2 | DRIVER | NaN | 858210.0 | NaN | FORD | TAURUS | IL | 2012.0 | NONE | PASSENGER | PERSONAL | N | STRAIGHT AHEAD | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Y | NaN | NaN | NaN | NaN | NaN | NaN | NaN | REAR-LEFT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 837764 | 905084 | 09a93b52a5387fec43780859b3b6539431ec1e8774372dbaecd12b28601b97821b500911dc61dba23259b03d4542f843c2d292a82c6a79aa8ad60e1a1f9cffd6 | JD273888 | 06/16/2020 08:30:00 AM | 1 | DRIVER | NaN | 858212.0 | NaN | DODGE | OTHER (EXPLAIN IN NARRATIVE) | IL | 2008.0 | NONE | PICKUP | UNKNOWN/NA | UNKNOWN | UNKNOWN/NA | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Y | UNKNOWN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 837765 | 905085 | 09a93b52a5387fec43780859b3b6539431ec1e8774372dbaecd12b28601b97821b500911dc61dba23259b03d4542f843c2d292a82c6a79aa8ad60e1a1f9cffd6 | JD273888 | 06/16/2020 08:30:00 AM | 2 | PARKED | NaN | 858205.0 | NaN | HYUNDAI | SONATA | IL | 2011.0 | NONE | PASSENGER | PERSONAL | E | PARKED | NaN | NaN | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Y | N | NaN | NaN | NaN | NaN | Y | Y | NaN | NaN | FRONT-RIGHT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |